{
  "statement":"select lo_orderkey, max(lo_orderkey), max(lo_shipmode), min(lo_shipmode) from lineorder_2 group by lo_orderkey",
  "table_meta":{
    "ssb_100g.lineorder_2":"CREATE TABLE `lineorder_2` (\n  `lo_orderkey` int(11) NOT NULL COMMENT \"\",\n  `lo_linenumber` int(11) NOT NULL COMMENT \"\",\n  `lo_custkey` int(11) NOT NULL COMMENT \"\",\n  `lo_partkey` int(11) NOT NULL COMMENT \"\",\n  `lo_suppkey` int(11) NOT NULL COMMENT \"\",\n  `lo_orderdate` int(11) NOT NULL COMMENT \"\",\n  `lo_orderpriority` varchar(16) NOT NULL COMMENT \"\",\n  `lo_shippriority` int(11) NOT NULL COMMENT \"\",\n  `lo_quantity` int(11) NOT NULL COMMENT \"\",\n  `lo_extendedprice` int(11) NOT NULL COMMENT \"\",\n  `lo_ordtotalprice` int(11) NOT NULL COMMENT \"\",\n  `lo_discount` int(11) NOT NULL COMMENT \"\",\n  `lo_revenue` int(11) NOT NULL COMMENT \"\",\n  `lo_supplycost` int(11) NOT NULL COMMENT \"\",\n  `lo_tax` int(11) NOT NULL COMMENT \"\",\n  `lo_commitdate` int(11) NOT NULL COMMENT \"\",\n  `lo_shipmode` varchar(11) NOT NULL COMMENT \"\"\n) ENGINE=OLAP\nDUPLICATE KEY(`lo_orderkey`)\nCOMMENT \"OLAP\"\nPARTITION BY RANGE(`lo_linenumber`)\n(PARTITION p1 VALUES [(\"-2147483648\"), (\"19930101\")),\nPARTITION p2 VALUES [(\"19930101\"), (\"19940101\")),\nPARTITION p3 VALUES [(\"19940101\"), (\"19950101\")),\nPARTITION p4 VALUES [(\"19950101\"), (\"19960101\")),\nPARTITION p5 VALUES [(\"19960101\"), (\"19970101\")),\nPARTITION p6 VALUES [(\"19970101\"), (\"19980101\")),\nPARTITION p7 VALUES [(\"19980101\"), (\"19990101\")))\nDISTRIBUTED BY HASH(`lo_custkey`) BUCKETS 48\nPROPERTIES (\n\"replication_num\" = \"1\",\n\"colocate_with\" = \"groupa1\",\n\"in_memory\" = \"false\",\n\"enable_persistent_index\" = \"false\",\n\"replicated_storage\" = \"true\",\n\"compression\" = \"LZ4\"\n);"
  },
  "table_row_count":{
    "ssb_100g.lineorder_2":{
      "p1":150000000
    }
  },
  "session_variables":"{\"runtime_join_filter_push_down_limit\":1024000,\"codegen_level\":0,\"cbo_cte_reuse\":false,\"character_set_connection\":\"utf8\",\"cbo_use_correlated_join_estimate\":true,\"enable_insert_strict\":true,\"enable_filter_unused_columns_in_scan_stage\":false,\"div_precision_increment\":4,\"tx_isolation\":\"REPEATABLE-READ\",\"wait_timeout\":28800,\"auto_increment_increment\":1,\"foreign_key_checks\":true,\"character_set_client\":\"utf8\",\"autocommit\":true,\"enable_column_expr_predicate\":false,\"character_set_results\":\"utf8\",\"parallel_fragment_exec_instance_num\":8,\"max_scan_key_num\":-1,\"enable_global_runtime_filter\":true,\"forward_to_master\":false,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"storage_engine\":\"olap\",\"cbo_enable_dp_join_reorder\":true,\"cbo_enable_low_cardinality_optimize\":false,\"tx_visible_wait_timeout\":10,\"cbo_max_reorder_node_use_exhaustive\":4,\"new_planner_optimize_timeout\":3000,\"force_schedule_local\":false,\"pipeline_dop\":1,\"enable_query_dump\":false,\"cbo_enable_greedy_join_reorder\":true,\"prefer_join_method\":\"broadcast\",\"load_mem_limit\":0,\"sql_select_limit\":9223372036854775807,\"profiling\":false,\"sql_safe_updates\":0,\"enable_pipeline_engine\":false,\"query_cache_type\":0,\"disable_colocate_join\":false,\"max_pushdown_conditions_per_column\":-1,\"enable_vectorized_engine\":true,\"net_write_timeout\":60,\"collation_database\":\"utf8_general_ci\",\"hash_join_push_down_right_table\":true,\"enable_exchange_pass_through\":true,\"new_planner_agg_stage\":0,\"pipeline_profile_level\":1,\"collation_connection\":\"utf8_general_ci\",\"resource_group\":\"normal\",\"broadcast_row_limit\":15000000,\"exec_mem_limit\":21474836480,\"cbo_max_reorder_node_use_dp\":10,\"disable_join_reorder\":false,\"enable_profile\":true,\"enable_groupby_use_output_alias\":false,\"net_buffer_length\":16384,\"transmission_compression_type\":\"LZ4\",\"enable_vectorized_insert\":true,\"interactive_timeout\":3600,\"enable_spilling\":false,\"batch_size\":1024,\"cbo_enable_replicated_join\":true,\"max_allowed_packet\":1048576,\"query_timeout\":180,\"enable_cbo\":true,\"collation_server\":\"utf8_general_ci\",\"time_zone\":\"Asia/Shanghai\",\"max_execution_time\":3000000,\"character_set_server\":\"utf8\",\"cbo_use_nth_exec_plan\":0,\"rewrite_count_distinct_to_bitmap_hll\":true,\"parallel_exchange_instance_num\":-1,\"sql_mode\":2,\"SQL_AUTO_IS_NULL\":false,\"event_scheduler\":\"OFF\",\"disable_streaming_preaggregations\":false}",
  "column_statistics":{
    "ssb_100g.lineorder_2":{
      "lo_orderkey":"[84348.0, 1.035985E7, 0.0, 4.0, 150000000] ESTIMATE",
      "lo_shipmode":"[-Infinity, Infinity, 0.0, 4.786802333333333, 7.0] ESTIMATE"
    }
  },
  "be_number":3,
  "exception":[

  ]
}
